package com.kedi.welfarecenter.read.dao.mapper;

import org.apache.ibatis.annotations.*;

import java.util.List;
import java.util.Map;

/**
* @Description:    医养融合
* @Author:         ytw
* @CreateDate:     2019/7/23 15:36
* @UpdateRemark:   修改内容
* @Version:        1.0
*/
@Mapper
public interface MedicalPenFuseMapper {
    
    /**
    * 方法实现说明
    * @author      查询所有医养融合信息
    *@param
    * @return
    * @exception   
    * @date        2019/7/24 13:57
    */
    @Select("select oldlife.name,oldlife_service.vist_time,oldlife_service.vist_content,oldlife_service.service_street from oldlife_service\n" +
            " left join oldlife on oldlife.oldlife_id=oldlife_service.oldlife_id ")
    List<Map<String,Object>> selectoldlifeservice();

    /**
    * 方法实现说明  查找是否有这个养老机构
    * @author      ytw
    *@param  name
    * @return
    * @exception
    * @date        2019/7/24 14:10
    */
    @Select("select oldlife.oldlife_id from oldlife where oldlife.name=#{name}")
    Integer findbyoldlifename(@Param("name")String name);


}
